Dataset statistics
| Number of variables | 36 |
|---|---|
| Number of observations | 5000 |
| Missing cells | 8939 |
| Missing cells (%) | 5.0% |
| Duplicate rows | 537 |
| Duplicate rows (%) | 10.7% |
| Total size in memory | 1.4 MiB |
| Average record size in memory | 288.0 B |
Variable types
| Categorical | 11 |
|---|---|
| Unsupported | 4 |
| DateTime | 5 |
| Numeric | 15 |
| Boolean | 1 |
item_tax has constant value "0" | Constant |
transport_cost_actual has constant value "0" | Constant |
| Dataset has 537 (10.7%) duplicate rows | Duplicates |
ordoro_id has a high cardinality: 3165 distinct values | High cardinality |
sku has a high cardinality: 930 distinct values | High cardinality |
item_sale_price is highly correlated with total_per_sku and 3 other fields | High correlation |
shipping_sale is highly correlated with mkp_actual_commission | High correlation |
total_per_sku is highly correlated with item_sale_price and 3 other fields | High correlation |
item_cost is highly correlated with item_sale_price and 3 other fields | High correlation |
mage_mkp_commission is highly correlated with mkp_actual_commission | High correlation |
mkp_estimated_commission is highly correlated with mkp_actual_commission | High correlation |
mkp_actual_commission is highly correlated with shipping_sale and 2 other fields | High correlation |
order_grand_total is highly correlated with item_sale_price and 3 other fields | High correlation |
order_place_time is highly correlated with order_total_time | High correlation |
order_total_time is highly correlated with order_place_time | High correlation |
gm_estimated is highly correlated with item_sale_price and 3 other fields | High correlation |
item_sale_price is highly correlated with total_per_sku and 4 other fields | High correlation |
total_per_sku is highly correlated with item_sale_price and 4 other fields | High correlation |
item_cost is highly correlated with item_sale_price and 2 other fields | High correlation |
mkp_actual_commission is highly correlated with item_sale_price and 1 other fields | High correlation |
order_grand_total is highly correlated with item_sale_price and 3 other fields | High correlation |
order_place_time is highly correlated with order_total_time | High correlation |
order_total_time is highly correlated with order_place_time | High correlation |
gm_estimated is highly correlated with item_sale_price and 2 other fields | High correlation |
item_sale_price is highly correlated with total_per_sku and 3 other fields | High correlation |
total_per_sku is highly correlated with item_sale_price and 3 other fields | High correlation |
item_cost is highly correlated with item_sale_price and 2 other fields | High correlation |
mkp_estimated_commission is highly correlated with mkp_actual_commission | High correlation |
mkp_actual_commission is highly correlated with mkp_estimated_commission | High correlation |
order_grand_total is highly correlated with item_sale_price and 2 other fields | High correlation |
order_place_time is highly correlated with order_total_time | High correlation |
order_total_time is highly correlated with order_place_time | High correlation |
gm_estimated is highly correlated with item_sale_price and 1 other fields | High correlation |
supplier_name is highly correlated with item_tax and 1 other fields | High correlation |
courier is highly correlated with item_tax and 1 other fields | High correlation |
cd_status is highly correlated with item_tax and 3 other fields | High correlation |
item_tax is highly correlated with supplier_name and 8 other fields | High correlation |
transport_cost_actual is highly correlated with supplier_name and 8 other fields | High correlation |
is_clogistique_order is highly correlated with cd_status and 3 other fields | High correlation |
order_status is highly correlated with item_tax and 2 other fields | High correlation |
line_type is highly correlated with item_tax and 1 other fields | High correlation |
mkp_name is highly correlated with cd_status and 3 other fields | High correlation |
line_status is highly correlated with item_tax and 2 other fields | High correlation |
mkp_name is highly correlated with supplier_name and 4 other fields | High correlation |
item_sale_price is highly correlated with shipping_sale and 9 other fields | High correlation |
shipping_sale is highly correlated with item_sale_price and 5 other fields | High correlation |
total_per_sku is highly correlated with item_sale_price and 9 other fields | High correlation |
supplier_name is highly correlated with mkp_name and 9 other fields | High correlation |
order_status is highly correlated with cancelled_value and 7 other fields | High correlation |
item_cost is highly correlated with item_sale_price and 7 other fields | High correlation |
cancelled_value is highly correlated with order_status and 3 other fields | High correlation |
transport_cost_est is highly correlated with item_sale_price and 8 other fields | High correlation |
courier is highly correlated with item_sale_price and 3 other fields | High correlation |
mage_mkp_commission is highly correlated with shipping_sale and 2 other fields | High correlation |
mkp_estimated_commission is highly correlated with mkp_name and 7 other fields | High correlation |
mkp_actual_commission is highly correlated with item_sale_price and 7 other fields | High correlation |
order_grand_total is highly correlated with item_sale_price and 8 other fields | High correlation |
max_shipping_date is highly correlated with mkp_name and 7 other fields | High correlation |
max_delivery_date is highly correlated with mkp_name and 7 other fields | High correlation |
cd_status is highly correlated with order_status and 6 other fields | High correlation |
is_clogistique_order is highly correlated with mkp_name and 2 other fields | High correlation |
line_status is highly correlated with order_status and 7 other fields | High correlation |
order_place_time is highly correlated with max_shipping_date and 2 other fields | High correlation |
order_delivery_time is highly correlated with order_status and 2 other fields | High correlation |
order_total_time is highly correlated with max_shipping_date and 3 other fields | High correlation |
gm_estimated is highly correlated with item_sale_price and 11 other fields | High correlation |
title has 5000 (100.0%) missing values | Missing |
courier has 1583 (31.7%) missing values | Missing |
cd_status has 2356 (47.1%) missing values | Missing |
ordoro_id is uniformly distributed | Uniform |
mkp_order_no is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
title is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
first_pick_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
last_delivery_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
shipping_sale has 1963 (39.3%) zeros | Zeros |
item_cost has 74 (1.5%) zeros | Zeros |
cancelled_value has 4928 (98.6%) zeros | Zeros |
transport_cost_est has 2463 (49.3%) zeros | Zeros |
mage_mkp_commission has 3895 (77.9%) zeros | Zeros |
mkp_estimated_commission has 2675 (53.5%) zeros | Zeros |
mkp_actual_commission has 2356 (47.1%) zeros | Zeros |
order_place_time has 157 (3.1%) zeros | Zeros |
order_prep_time has 2063 (41.3%) zeros | Zeros |
order_delivery_time has 2212 (44.2%) zeros | Zeros |
order_total_time has 157 (3.1%) zeros | Zeros |
Reproduction
| Analysis started | 2022-06-24 11:54:47.204783 |
|---|---|
| Analysis finished | 2022-06-24 11:55:37.303956 |
| Duration | 50.1 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| ORDER LINE | |
|---|---|
| FULL REPLACEMENT | 13 |
| PARTIAL REPLACEMENT | 7 |
Length
| Max length | 19 |
|---|---|
| Median length | 10 |
| Mean length | 10.0282 |
| Min length | 10 |
Characters and Unicode
| Total characters | 50141 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ORDER LINE |
|---|---|
| 2nd row | ORDER LINE |
| 3rd row | ORDER LINE |
| 4th row | ORDER LINE |
| 5th row | ORDER LINE |
Common Values
| Value | Count | Frequency (%) |
| ORDER LINE | 4980 | |
| FULL REPLACEMENT | 13 | 0.3% |
| PARTIAL REPLACEMENT | 7 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| order | 4980 | |
| line | 4980 | |
| replacement | 20 | 0.2% |
| full | 13 | 0.1% |
| partial | 7 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 10020 | |
| R | 9987 | |
| L | 5033 | |
| 5000 | ||
| N | 5000 | |
| I | 4987 | |
| O | 4980 | |
| D | 4980 | |
| A | 34 | 0.1% |
| P | 27 | 0.1% |
| Other values (5) | 93 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 45141 | |
| Space Separator | 5000 | 10.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 10020 | |
| R | 9987 | |
| L | 5033 | |
| N | 5000 | |
| I | 4987 | |
| O | 4980 | |
| D | 4980 | |
| A | 34 | 0.1% |
| P | 27 | 0.1% |
| T | 27 | 0.1% |
| Other values (4) | 66 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 45141 | |
| Common | 5000 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 10020 | |
| R | 9987 | |
| L | 5033 | |
| N | 5000 | |
| I | 4987 | |
| O | 4980 | |
| D | 4980 | |
| A | 34 | 0.1% |
| P | 27 | 0.1% |
| T | 27 | 0.1% |
| Other values (4) | 66 | 0.1% |
Common
| Value | Count | Frequency (%) |
| 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 50141 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 10020 | |
| R | 9987 | |
| L | 5033 | |
| 5000 | ||
| N | 5000 | |
| I | 4987 | |
| O | 4980 | |
| D | 4980 | |
| A | 34 | 0.1% |
| P | 27 | 0.1% |
| Other values (5) | 93 | 0.2% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| CDiscount | |
|---|---|
| Monechelle | |
| conforama | |
| CLogistique | |
| Fnac | 107 |
| Other values (3) | 50 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.367 |
| Min length | 4 |
Characters and Unicode
| Total characters | 46835 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CDiscount |
|---|---|
| 2nd row | CDiscount |
| 3rd row | PriceMinister |
| 4th row | Monechelle |
| 5th row | Monechelle |
Common Values
| Value | Count | Frequency (%) |
| CDiscount | 2219 | |
| Monechelle | 1516 | |
| conforama | 681 | 13.6% |
| CLogistique | 427 | 8.5% |
| Fnac | 107 | 2.1% |
| Darty | 25 | 0.5% |
| RueDuCommerce | 16 | 0.3% |
| PriceMinister | 9 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| cdiscount | 2219 | |
| monechelle | 1516 | |
| conforama | 681 | 13.6% |
| clogistique | 427 | 8.5% |
| fnac | 107 | 2.1% |
| darty | 25 | 0.5% |
| rueducommerce | 16 | 0.3% |
| priceminister | 9 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 5540 | |
| e | 5041 | |
| c | 4548 | |
| n | 4532 | |
| i | 3100 | 6.6% |
| l | 3032 | 6.5% |
| t | 2680 | 5.7% |
| u | 2678 | 5.7% |
| C | 2662 | 5.7% |
| s | 2655 | 5.7% |
| Other values (14) | 10367 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 39829 | |
| Uppercase Letter | 7006 | 15.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 5540 | |
| e | 5041 | |
| c | 4548 | |
| n | 4532 | |
| i | 3100 | |
| l | 3032 | |
| t | 2680 | |
| u | 2678 | |
| s | 2655 | |
| h | 1516 | 3.8% |
| Other values (7) | 4507 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2662 | |
| D | 2260 | |
| M | 1525 | |
| L | 427 | 6.1% |
| F | 107 | 1.5% |
| R | 16 | 0.2% |
| P | 9 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 46835 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 5540 | |
| e | 5041 | |
| c | 4548 | |
| n | 4532 | |
| i | 3100 | 6.6% |
| l | 3032 | 6.5% |
| t | 2680 | 5.7% |
| u | 2678 | 5.7% |
| C | 2662 | 5.7% |
| s | 2655 | 5.7% |
| Other values (14) | 10367 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46835 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 5540 | |
| e | 5041 | |
| c | 4548 | |
| n | 4532 | |
| i | 3100 | 6.6% |
| l | 3032 | 6.5% |
| t | 2680 | 5.7% |
| u | 2678 | 5.7% |
| C | 2662 | 5.7% |
| s | 2655 | 5.7% |
| Other values (14) | 10367 |
order_date
Date
| Distinct | 2928 |
|---|---|
| Distinct (%) | 58.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2020-09-08 20:30:00 |
|---|---|
| Maximum | 2020-10-03 09:22:00 |
| Distinct | 3165 |
|---|---|
| Distinct (%) | 63.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| 1-300057096 | 8 |
|---|---|
| 1-300054839 | 8 |
| 1-300057378 | 8 |
| 1-300057368 | 8 |
| 1-300056841 | 8 |
| Other values (3160) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 55000 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1609 ? |
|---|---|
| Unique (%) | 32.2% |
Sample
| 1st row | 1-300055647 |
|---|---|
| 2nd row | 1-300055647 |
| 3rd row | 1-300056586 |
| 4th row | 1-300056600 |
| 5th row | 1-300056647 |
Common Values
| Value | Count | Frequency (%) |
| 1-300057096 | 8 | 0.2% |
| 1-300054839 | 8 | 0.2% |
| 1-300057378 | 8 | 0.2% |
| 1-300057368 | 8 | 0.2% |
| 1-300056841 | 8 | 0.2% |
| 1-300056679 | 8 | 0.2% |
| 1-300055743 | 6 | 0.1% |
| 1-300055781 | 6 | 0.1% |
| 1-300055611 | 6 | 0.1% |
| 1-300055679 | 6 | 0.1% |
| Other values (3155) | 4928 |
Length
| Value | Count | Frequency (%) |
| 1-300057096 | 8 | 0.2% |
| 1-300057378 | 8 | 0.2% |
| 1-300057368 | 8 | 0.2% |
| 1-300056841 | 8 | 0.2% |
| 1-300056679 | 8 | 0.2% |
| 1-300054839 | 8 | 0.2% |
| 1-300054828 | 6 | 0.1% |
| 1-300056388 | 6 | 0.1% |
| 1-300054843 | 6 | 0.1% |
| 1-300057001 | 6 | 0.1% |
| Other values (3155) | 4928 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 16541 | |
| 5 | 7991 | |
| 1 | 6548 | 11.9% |
| 3 | 6443 | 11.7% |
| - | 5000 | 9.1% |
| 7 | 3141 | 5.7% |
| 6 | 2828 | 5.1% |
| 4 | 1818 | 3.3% |
| 8 | 1692 | 3.1% |
| 9 | 1571 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 50000 | |
| Dash Punctuation | 5000 | 9.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 16541 | |
| 5 | 7991 | |
| 1 | 6548 | 13.1% |
| 3 | 6443 | 12.9% |
| 7 | 3141 | 6.3% |
| 6 | 2828 | 5.7% |
| 4 | 1818 | 3.6% |
| 8 | 1692 | 3.4% |
| 9 | 1571 | 3.1% |
| 2 | 1427 | 2.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 55000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 16541 | |
| 5 | 7991 | |
| 1 | 6548 | 11.9% |
| 3 | 6443 | 11.7% |
| - | 5000 | 9.1% |
| 7 | 3141 | 5.7% |
| 6 | 2828 | 5.1% |
| 4 | 1818 | 3.3% |
| 8 | 1692 | 3.1% |
| 9 | 1571 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 55000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 16541 | |
| 5 | 7991 | |
| 1 | 6548 | 11.9% |
| 3 | 6443 | 11.7% |
| - | 5000 | 9.1% |
| 7 | 3141 | 5.7% |
| 6 | 2828 | 5.1% |
| 4 | 1818 | 3.3% |
| 8 | 1692 | 3.1% |
| 9 | 1571 | 2.9% |
| Distinct | 930 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| TOP-MalwaM6/140/white | 366 |
|---|---|
| TOP-MalwaM3/white | 143 |
| AKO-K120-6SZ-BIALA | 108 |
| TOP-MalwaM6/140/sonoma | 93 |
| AKO-K60-5SZ-BIALA | 83 |
| Other values (925) |
Length
| Max length | 50 |
|---|---|
| Median length | 43 |
| Mean length | 20.2334 |
| Min length | 7 |
Characters and Unicode
| Total characters | 101167 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 279 ? |
|---|---|
| Unique (%) | 5.6% |
Sample
| 1st row | KK-KKLJOYBLU00000 |
|---|---|
| 2nd row | KK-KKLJOYBLU00000 |
| 3rd row | KK-KKWMOOVNAV0000 |
| 4th row | KK-KKLJOYBLU000AC |
| 5th row | KK-KKLJOYBLU000AC |
Common Values
| Value | Count | Frequency (%) |
| TOP-MalwaM6/140/white | 366 | 7.3% |
| TOP-MalwaM3/white | 143 | 2.9% |
| AKO-K120-6SZ-BIALA | 108 | 2.2% |
| TOP-MalwaM6/140/sonoma | 93 | 1.9% |
| AKO-K60-5SZ-BIALA | 83 | 1.7% |
| AKO-K120-8SZ-BIALA | 78 | 1.6% |
| TOP-S33/sonoma | 78 | 1.6% |
| TOP-2D4S/120/dab_artisan | 71 | 1.4% |
| TOP-S33/white | 71 | 1.4% |
| TOP-MalwaM4/white | 56 | 1.1% |
| Other values (920) | 3853 |
Length
| Value | Count | Frequency (%) |
| top-malwam6/140/white | 366 | 7.1% |
| top-malwam3/white | 143 | 2.8% |
| ako-k120-6sz-biala | 108 | 2.1% |
| top-malwam6/140/sonoma | 93 | 1.8% |
| ako-k60-5sz-biala | 83 | 1.6% |
| ako-k120-8sz-biala | 78 | 1.5% |
| top-s33/sonoma | 78 | 1.5% |
| top-2d4s/120/dab_artisan | 71 | 1.4% |
| top-s33/white | 71 | 1.4% |
| top-malwam2/white | 59 | 1.2% |
| Other values (921) | 3973 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 11974 | 11.8% |
| O | 5810 | 5.7% |
| A | 5108 | 5.0% |
| a | 4573 | 4.5% |
| M | 3611 | 3.6% |
| P | 3385 | 3.3% |
| K | 3233 | 3.2% |
| 0 | 3231 | 3.2% |
| T | 3231 | 3.2% |
| / | 2934 | 2.9% |
| Other values (57) | 54077 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 44649 | |
| Lowercase Letter | 27356 | |
| Decimal Number | 13791 | 13.6% |
| Dash Punctuation | 11974 | 11.8% |
| Other Punctuation | 3018 | 3.0% |
| Connector Punctuation | 256 | 0.3% |
| Space Separator | 123 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 5810 | |
| A | 5108 | |
| M | 3611 | 8.1% |
| P | 3385 | 7.6% |
| K | 3233 | 7.2% |
| T | 3231 | 7.2% |
| S | 2616 | 5.9% |
| L | 2223 | 5.0% |
| B | 2217 | 5.0% |
| I | 1838 | 4.1% |
| Other values (16) | 11377 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4573 | |
| e | 2520 | |
| i | 2295 | |
| w | 2280 | |
| o | 2260 | |
| t | 1992 | 7.3% |
| l | 1815 | 6.6% |
| n | 1657 | 6.1% |
| h | 1585 | 5.8% |
| s | 1209 | 4.4% |
| Other values (16) | 5170 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3231 | |
| 1 | 2655 | |
| 2 | 1725 | |
| 4 | 1620 | |
| 6 | 1545 | |
| 3 | 1351 | |
| 5 | 643 | 4.7% |
| 8 | 518 | 3.8% |
| 7 | 277 | 2.0% |
| 9 | 226 | 1.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2934 | |
| . | 84 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 11974 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 256 |
Space Separator
| Value | Count | Frequency (%) |
| 123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 72005 | |
| Common | 29162 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 5810 | 8.1% |
| A | 5108 | 7.1% |
| a | 4573 | 6.4% |
| M | 3611 | 5.0% |
| P | 3385 | 4.7% |
| K | 3233 | 4.5% |
| T | 3231 | 4.5% |
| S | 2616 | 3.6% |
| e | 2520 | 3.5% |
| i | 2295 | 3.2% |
| Other values (42) | 35623 |
Common
| Value | Count | Frequency (%) |
| - | 11974 | |
| 0 | 3231 | 11.1% |
| / | 2934 | 10.1% |
| 1 | 2655 | 9.1% |
| 2 | 1725 | 5.9% |
| 4 | 1620 | 5.6% |
| 6 | 1545 | 5.3% |
| 3 | 1351 | 4.6% |
| 5 | 643 | 2.2% |
| 8 | 518 | 1.8% |
| Other values (5) | 966 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 101167 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 11974 | 11.8% |
| O | 5810 | 5.7% |
| A | 5108 | 5.0% |
| a | 4573 | 4.5% |
| M | 3611 | 3.6% |
| P | 3385 | 3.3% |
| K | 3233 | 3.2% |
| 0 | 3231 | 3.2% |
| T | 3231 | 3.2% |
| / | 2934 | 2.9% |
| Other values (57) | 54077 |
item_sale_price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 257 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 126.089582 |
| Minimum | 0 |
|---|---|
| Maximum | 869.95 |
| Zeros | 14 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 44.95 |
| Q1 | 77.95 |
| median | 99.95 |
| Q3 | 139.95 |
| 95-th percentile | 259.95 |
| Maximum | 869.95 |
| Range | 869.95 |
| Interquartile range (IQR) | 62 |
Descriptive statistics
| Standard deviation | 94.96599609 |
|---|---|
| Coefficient of variation (CV) | 0.7531629068 |
| Kurtosis | 17.02785374 |
| Mean | 126.089582 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 3.629804934 |
| Sum | 630447.91 |
| Variance | 9018.540414 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 89.95 | 563 | 11.3% |
| 99.95 | 218 | 4.4% |
| 74.95 | 214 | 4.3% |
| 79.95 | 195 | 3.9% |
| 114.95 | 167 | 3.3% |
| 119.95 | 164 | 3.3% |
| 134.95 | 141 | 2.8% |
| 139.95 | 135 | 2.7% |
| 39.95 | 123 | 2.5% |
| 109.95 | 120 | 2.4% |
| Other values (247) | 2960 |
| Value | Count | Frequency (%) |
| 0 | 14 | |
| 9.9 | 2 | < 0.1% |
| 12.95 | 1 | < 0.1% |
| 16.95 | 2 | < 0.1% |
| 19.95 | 1 | < 0.1% |
| 22.9 | 1 | < 0.1% |
| 22.95 | 5 | 0.1% |
| 24.95 | 2 | < 0.1% |
| 26.95 | 1 | < 0.1% |
| 29.05 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 869.95 | 3 | |
| 829.95 | 1 | < 0.1% |
| 759.95 | 3 | |
| 757.95 | 2 | < 0.1% |
| 751.95 | 2 | < 0.1% |
| 744.95 | 1 | < 0.1% |
| 708.95 | 2 | < 0.1% |
| 706.95 | 2 | < 0.1% |
| 699.95 | 7 | |
| 688.95 | 2 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5000 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5000 |
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.743202 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 1963 |
| Zeros (%) | 39.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 9.95 |
| Q3 | 19.95 |
| 95-th percentile | 19.95 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 19.95 |
Descriptive statistics
| Standard deviation | 9.026153024 |
|---|---|
| Coefficient of variation (CV) | 0.9264052027 |
| Kurtosis | 0.8130880075 |
| Mean | 9.743202 |
| Median Absolute Deviation (MAD) | 9.95 |
| Skewness | 0.4013176443 |
| Sum | 48716.01 |
| Variance | 81.47143841 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1963 | |
| 19.95 | 1801 | |
| 9.95 | 973 | |
| 4.98 | 62 | 1.2% |
| 12.48 | 44 | 0.9% |
| 14.95 | 20 | 0.4% |
| 9.99 | 16 | 0.3% |
| 19.99 | 16 | 0.3% |
| 3.99 | 13 | 0.3% |
| 9.98 | 12 | 0.2% |
| Other values (20) | 80 | 1.6% |
| Value | Count | Frequency (%) |
| 0 | 1963 | |
| 0.97 | 2 | < 0.1% |
| 1.2 | 2 | < 0.1% |
| 1.27 | 1 | < 0.1% |
| 1.5 | 6 | 0.1% |
| 2.07 | 2 | < 0.1% |
| 2.71 | 1 | < 0.1% |
| 2.99 | 5 | 0.1% |
| 3.32 | 3 | 0.1% |
| 3.5 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 1 | < 0.1% |
| 50 | 2 | < 0.1% |
| 49.95 | 4 | 0.1% |
| 39.95 | 5 | 0.1% |
| 34.95 | 6 | 0.1% |
| 24.95 | 4 | 0.1% |
| 19.99 | 16 | 0.3% |
| 19.95 | 1801 | |
| 14.98 | 2 | < 0.1% |
| 14.95 | 20 | 0.4% |
| Distinct | 426 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 135.832784 |
| Minimum | 0 |
|---|---|
| Maximum | 919.9 |
| Zeros | 9 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 49.95 |
| Q1 | 79.95 |
| median | 109.9 |
| Q3 | 151.995 |
| 95-th percentile | 269.9015 |
| Maximum | 919.9 |
| Range | 919.9 |
| Interquartile range (IQR) | 72.045 |
Descriptive statistics
| Standard deviation | 96.76917272 |
|---|---|
| Coefficient of variation (CV) | 0.7124139686 |
| Kurtosis | 16.50259543 |
| Mean | 135.832784 |
| Median Absolute Deviation (MAD) | 31.95 |
| Skewness | 3.527433161 |
| Sum | 679163.92 |
| Variance | 9364.272788 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 109.9 | 343 | 6.9% |
| 74.95 | 167 | 3.3% |
| 134.9 | 141 | 2.8% |
| 99.9 | 117 | 2.3% |
| 89.95 | 109 | 2.2% |
| 139.9 | 109 | 2.2% |
| 99.95 | 103 | 2.1% |
| 77.95 | 102 | 2.0% |
| 89.9 | 101 | 2.0% |
| 79.95 | 92 | 1.8% |
| Other values (416) | 3616 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 9.99 | 4 | |
| 19.85 | 2 | < 0.1% |
| 19.95 | 1 | < 0.1% |
| 22.9 | 1 | < 0.1% |
| 24.95 | 2 | < 0.1% |
| 29.9 | 1 | < 0.1% |
| 29.95 | 3 | 0.1% |
| 32.85 | 1 | < 0.1% |
| 32.9 | 5 |
| Value | Count | Frequency (%) |
| 919.9 | 2 | < 0.1% |
| 889.9 | 1 | < 0.1% |
| 849.9 | 1 | < 0.1% |
| 779.9 | 3 | |
| 777.9 | 2 | < 0.1% |
| 764.9 | 1 | < 0.1% |
| 751.95 | 2 | < 0.1% |
| 728.9 | 2 | < 0.1% |
| 719.9 | 6 | |
| 706.95 | 2 | < 0.1% |
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| TOP | |
|---|---|
| AKO | |
| MOB | |
| KD | 169 |
| HAA | 79 |
| Other values (32) |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 2.9842 |
| Min length | 2 |
Characters and Unicode
| Total characters | 14921 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | KK |
|---|---|
| 2nd row | KK |
| 3rd row | KK |
| 4th row | KK |
| 5th row | KK |
Common Values
| Value | Count | Frequency (%) |
| TOP | 2408 | |
| AKO | 1234 | |
| MOB | 412 | 8.2% |
| KD | 169 | 3.4% |
| HAA | 79 | 1.6% |
| MAL | 72 | 1.4% |
| REG | 71 | 1.4% |
| BEL | 68 | 1.4% |
| CARE | 65 | 1.3% |
| PM | 50 | 1.0% |
| Other values (27) | 372 | 7.4% |
Length
| Value | Count | Frequency (%) |
| top | 2408 | |
| ako | 1234 | |
| mob | 412 | 8.2% |
| kd | 169 | 3.4% |
| haa | 79 | 1.6% |
| mal | 72 | 1.4% |
| reg | 71 | 1.4% |
| bel | 68 | 1.4% |
| care | 65 | 1.3% |
| pm | 50 | 1.0% |
| Other values (27) | 372 | 7.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 4180 | |
| P | 2459 | |
| T | 2448 | |
| A | 1545 | 10.4% |
| K | 1463 | 9.8% |
| M | 622 | 4.2% |
| B | 530 | 3.6% |
| E | 224 | 1.5% |
| D | 208 | 1.4% |
| L | 176 | 1.2% |
| Other values (12) | 1066 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 14921 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 4180 | |
| P | 2459 | |
| T | 2448 | |
| A | 1545 | 10.4% |
| K | 1463 | 9.8% |
| M | 622 | 4.2% |
| B | 530 | 3.6% |
| E | 224 | 1.5% |
| D | 208 | 1.4% |
| L | 176 | 1.2% |
| Other values (12) | 1066 | 7.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14921 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 4180 | |
| P | 2459 | |
| T | 2448 | |
| A | 1545 | 10.4% |
| K | 1463 | 9.8% |
| M | 622 | 4.2% |
| B | 530 | 3.6% |
| E | 224 | 1.5% |
| D | 208 | 1.4% |
| L | 176 | 1.2% |
| Other values (12) | 1066 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14921 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 4180 | |
| P | 2459 | |
| T | 2448 | |
| A | 1545 | 10.4% |
| K | 1463 | 9.8% |
| M | 622 | 4.2% |
| B | 530 | 3.6% |
| E | 224 | 1.5% |
| D | 208 | 1.4% |
| L | 176 | 1.2% |
| Other values (12) | 1066 | 7.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| shipped | |
|---|---|
| awaiting_fulfillment | |
| cancelled | 72 |
Length
| Max length | 20 |
|---|---|
| Median length | 7 |
| Mean length | 10.609 |
| Min length | 7 |
Characters and Unicode
| Total characters | 53045 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | shipped |
|---|---|
| 2nd row | shipped |
| 3rd row | shipped |
| 4th row | shipped |
| 5th row | shipped |
Common Values
| Value | Count | Frequency (%) |
| shipped | 3551 | |
| awaiting_fulfillment | 1377 | 27.5% |
| cancelled | 72 | 1.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| shipped | 3551 | |
| awaiting_fulfillment | 1377 | 27.5% |
| cancelled | 72 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 7682 | |
| p | 7102 | |
| e | 5072 | |
| l | 4275 | |
| d | 3623 | 6.8% |
| s | 3551 | 6.7% |
| h | 3551 | 6.7% |
| a | 2826 | 5.3% |
| n | 2826 | 5.3% |
| f | 2754 | 5.2% |
| Other values (7) | 9783 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 51668 | |
| Connector Punctuation | 1377 | 2.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 7682 | |
| p | 7102 | |
| e | 5072 | |
| l | 4275 | |
| d | 3623 | |
| s | 3551 | |
| h | 3551 | |
| a | 2826 | 5.5% |
| n | 2826 | 5.5% |
| f | 2754 | 5.3% |
| Other values (6) | 8406 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1377 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 51668 | |
| Common | 1377 | 2.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 7682 | |
| p | 7102 | |
| e | 5072 | |
| l | 4275 | |
| d | 3623 | |
| s | 3551 | |
| h | 3551 | |
| a | 2826 | 5.5% |
| n | 2826 | 5.5% |
| f | 2754 | 5.3% |
| Other values (6) | 8406 |
Common
| Value | Count | Frequency (%) |
| _ | 1377 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 53045 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 7682 | |
| p | 7102 | |
| e | 5072 | |
| l | 4275 | |
| d | 3623 | 6.8% |
| s | 3551 | 6.7% |
| h | 3551 | 6.7% |
| a | 2826 | 5.3% |
| n | 2826 | 5.3% |
| f | 2754 | 5.2% |
| Other values (7) | 9783 |
item_cost
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 462 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.622798 |
| Minimum | 0 |
|---|---|
| Maximum | 333.78 |
| Zeros | 74 |
| Zeros (%) | 1.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.78 |
| Q1 | 24.87 |
| median | 39.08 |
| Q3 | 50.97 |
| 95-th percentile | 89.53 |
| Maximum | 333.78 |
| Range | 333.78 |
| Interquartile range (IQR) | 26.1 |
Descriptive statistics
| Standard deviation | 28.9859361 |
|---|---|
| Coefficient of variation (CV) | 0.6800570929 |
| Kurtosis | 17.6382357 |
| Mean | 42.622798 |
| Median Absolute Deviation (MAD) | 13.32 |
| Skewness | 3.363337706 |
| Sum | 213113.99 |
| Variance | 840.1844914 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 43.95 | 510 | 10.2% |
| 24.87 | 226 | 4.5% |
| 23.98 | 178 | 3.6% |
| 24.33 | 136 | 2.7% |
| 39.16 | 125 | 2.5% |
| 35.59 | 119 | 2.4% |
| 12.17 | 110 | 2.2% |
| 30.24 | 109 | 2.2% |
| 65.99 | 103 | 2.1% |
| 50.97 | 103 | 2.1% |
| Other values (452) | 3281 |
| Value | Count | Frequency (%) |
| 0 | 74 | |
| 0.99 | 1 | < 0.1% |
| 4.53 | 2 | < 0.1% |
| 4.7 | 1 | < 0.1% |
| 5.1 | 2 | < 0.1% |
| 6.46 | 1 | < 0.1% |
| 6.49 | 2 | < 0.1% |
| 7.65 | 5 | 0.1% |
| 7.99 | 3 | 0.1% |
| 8.71 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 333.78 | 1 | < 0.1% |
| 303.12 | 1 | < 0.1% |
| 264.4 | 1 | < 0.1% |
| 259.12 | 2 | < 0.1% |
| 256.89 | 2 | < 0.1% |
| 242.54 | 2 | < 0.1% |
| 231 | 2 | < 0.1% |
| 221.05 | 1 | < 0.1% |
| 216.45 | 7 | |
| 214.86 | 6 |
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.016876 |
| Minimum | 0 |
|---|---|
| Maximum | 741.58 |
| Zeros | 4928 |
| Zeros (%) | 98.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 741.58 |
| Range | 741.58 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 21.07987649 |
|---|---|
| Coefficient of variation (CV) | 10.45174641 |
| Kurtosis | 432.6065269 |
| Mean | 2.016876 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.3687368 |
| Sum | 10084.38 |
| Variance | 444.3611927 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4928 | |
| 105.75 | 4 | 0.1% |
| 166.63 | 4 | 0.1% |
| 149.92 | 4 | 0.1% |
| 112.46 | 2 | < 0.1% |
| 138.18 | 2 | < 0.1% |
| 73.13 | 2 | < 0.1% |
| 109.72 | 2 | < 0.1% |
| 299.92 | 2 | < 0.1% |
| 65.75 | 2 | < 0.1% |
| Other values (34) | 48 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 4928 | |
| 27.38 | 1 | < 0.1% |
| 42.41 | 2 | < 0.1% |
| 43.21 | 1 | < 0.1% |
| 46.28 | 1 | < 0.1% |
| 49.96 | 1 | < 0.1% |
| 58.25 | 2 | < 0.1% |
| 62.42 | 2 | < 0.1% |
| 63.25 | 2 | < 0.1% |
| 65.75 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 741.58 | 1 | < 0.1% |
| 499.92 | 1 | < 0.1% |
| 340.71 | 2 | |
| 299.92 | 2 | |
| 283.25 | 1 | < 0.1% |
| 214.88 | 2 | |
| 191.63 | 2 | |
| 183.25 | 1 | < 0.1% |
| 166.63 | 4 | |
| 162.42 | 2 |
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.465766 |
| Minimum | 0 |
|---|---|
| Maximum | 177.89 |
| Zeros | 2463 |
| Zeros (%) | 49.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 11.32 |
| Q3 | 16 |
| 95-th percentile | 31.9 |
| Maximum | 177.89 |
| Range | 177.89 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 16.1640651 |
|---|---|
| Coefficient of variation (CV) | 1.409767572 |
| Kurtosis | 26.91198677 |
| Mean | 11.465766 |
| Median Absolute Deviation (MAD) | 11.32 |
| Skewness | 3.74214941 |
| Sum | 57328.83 |
| Variance | 261.2770005 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2463 | |
| 16 | 855 | 17.1% |
| 15.95 | 613 | 12.3% |
| 29.61 | 282 | 5.6% |
| 31.9 | 201 | 4.0% |
| 35.85 | 88 | 1.8% |
| 30.86 | 60 | 1.2% |
| 11.32 | 46 | 0.9% |
| 11.7 | 41 | 0.8% |
| 13.9 | 25 | 0.5% |
| Other values (52) | 326 | 6.5% |
| Value | Count | Frequency (%) |
| 0 | 2463 | |
| 9.05 | 8 | 0.2% |
| 10.07 | 3 | 0.1% |
| 10.81 | 2 | < 0.1% |
| 11.31 | 16 | 0.3% |
| 11.32 | 46 | 0.9% |
| 11.7 | 41 | 0.8% |
| 11.79 | 2 | < 0.1% |
| 12.29 | 4 | 0.1% |
| 12.84 | 15 | 0.3% |
| Value | Count | Frequency (%) |
| 177.89 | 8 | |
| 145 | 3 | 0.1% |
| 114.03 | 17 | |
| 99.83 | 8 | |
| 89.54 | 7 | |
| 87.75 | 2 | < 0.1% |
| 83.7 | 2 | < 0.1% |
| 71.7 | 1 | < 0.1% |
| 67.75 | 13 | |
| 52.52 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1583 |
| Missing (%) | 31.7% |
| Memory size | 39.2 KiB |
| UPS | |
|---|---|
| DPD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 10251 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UPS |
|---|---|
| 2nd row | UPS |
| 3rd row | DPD |
| 4th row | DPD |
| 5th row | UPS |
Common Values
| Value | Count | Frequency (%) |
| UPS | 1927 | |
| DPD | 1490 | |
| (Missing) | 1583 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| ups | 1927 | |
| dpd | 1490 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 3417 | |
| D | 2980 | |
| U | 1927 | |
| S | 1927 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10251 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 3417 | |
| D | 2980 | |
| U | 1927 | |
| S | 1927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10251 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 3417 | |
| D | 2980 | |
| U | 1927 | |
| S | 1927 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10251 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 3417 | |
| D | 2980 | |
| U | 1927 | |
| S | 1927 |
| Distinct | 202 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.899702 |
| Minimum | 0 |
|---|---|
| Maximum | 92.34 |
| Zeros | 3895 |
| Zeros (%) | 77.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3.72 |
| Maximum | 92.34 |
| Range | 92.34 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.954292531 |
|---|---|
| Coefficient of variation (CV) | 4.395113638 |
| Kurtosis | 300.005005 |
| Mean | 0.899702 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.48905634 |
| Sum | 4498.51 |
| Variance | 15.63642942 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3895 | |
| 2.64 | 107 | 2.1% |
| 3.24 | 44 | 0.9% |
| 1.8 | 44 | 0.9% |
| 1.87 | 33 | 0.7% |
| 2.88 | 32 | 0.6% |
| 3.36 | 31 | 0.6% |
| 2.4 | 31 | 0.6% |
| 1.92 | 31 | 0.6% |
| 2.63 | 26 | 0.5% |
| Other values (192) | 726 | 14.5% |
| Value | Count | Frequency (%) |
| 0 | 3895 | |
| 0.78 | 1 | < 0.1% |
| 0.79 | 2 | < 0.1% |
| 0.86 | 4 | 0.1% |
| 0.89 | 1 | < 0.1% |
| 0.95 | 1 | < 0.1% |
| 0.96 | 19 | 0.4% |
| 1 | 4 | 0.1% |
| 1.03 | 1 | < 0.1% |
| 1.04 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 92.34 | 2 | < 0.1% |
| 77.95 | 2 | < 0.1% |
| 76.75 | 1 | < 0.1% |
| 74.95 | 4 | |
| 30 | 6 | |
| 27.12 | 1 | < 0.1% |
| 17.48 | 2 | < 0.1% |
| 17.28 | 1 | < 0.1% |
| 16.97 | 4 | |
| 16.7 | 2 | < 0.1% |
| Distinct | 237 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.738542 |
| Minimum | 0 |
|---|---|
| Maximum | 141.09 |
| Zeros | 2675 |
| Zeros (%) | 53.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 17.24 |
| 95-th percentile | 30.59 |
| Maximum | 141.09 |
| Range | 141.09 |
| Interquartile range (IQR) | 17.24 |
Descriptive statistics
| Standard deviation | 14.05669497 |
|---|---|
| Coefficient of variation (CV) | 1.443408569 |
| Kurtosis | 11.34607209 |
| Mean | 9.738542 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.566373589 |
| Sum | 48692.71 |
| Variance | 197.5906734 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2675 | |
| 20.24 | 93 | 1.9% |
| 13.49 | 86 | 1.7% |
| 14.99 | 78 | 1.6% |
| 20.99 | 77 | 1.5% |
| 11.99 | 68 | 1.4% |
| 17.99 | 56 | 1.1% |
| 15.29 | 50 | 1.0% |
| 11.54 | 48 | 1.0% |
| 22.09 | 47 | 0.9% |
| Other values (227) | 1722 |
| Value | Count | Frequency (%) |
| 0 | 2675 | |
| 2.54 | 2 | < 0.1% |
| 3.74 | 2 | < 0.1% |
| 4.49 | 3 | 0.1% |
| 4.79 | 2 | < 0.1% |
| 4.94 | 2 | < 0.1% |
| 5.09 | 18 | 0.4% |
| 5.24 | 2 | < 0.1% |
| 5.43 | 1 | < 0.1% |
| 5.94 | 8 | 0.2% |
| Value | Count | Frequency (%) |
| 141.09 | 1 | < 0.1% |
| 112.79 | 2 | < 0.1% |
| 106.04 | 2 | < 0.1% |
| 104.99 | 1 | < 0.1% |
| 103.34 | 2 | < 0.1% |
| 102.84 | 1 | < 0.1% |
| 101.82 | 1 | < 0.1% |
| 99.74 | 1 | < 0.1% |
| 95.99 | 3 | |
| 93.74 | 6 |
mkp_actual_commission
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 486 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.56719 |
| Minimum | 0 |
|---|---|
| Maximum | 155.09 |
| Zeros | 2356 |
| Zeros (%) | 47.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5.49 |
| Q3 | 13.5175 |
| 95-th percentile | 32.98 |
| Maximum | 155.09 |
| Range | 155.09 |
| Interquartile range (IQR) | 13.5175 |
Descriptive statistics
| Standard deviation | 15.30695413 |
|---|---|
| Coefficient of variation (CV) | 1.599942525 |
| Kurtosis | 19.42986013 |
| Mean | 9.56719 |
| Median Absolute Deviation (MAD) | 5.49 |
| Skewness | 3.585909704 |
| Sum | 47835.95 |
| Variance | 234.3028447 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2356 | |
| 5.49 | 105 | 2.1% |
| 5.99 | 77 | 1.5% |
| 8.13 | 65 | 1.3% |
| 11.83 | 51 | 1.0% |
| 6.23 | 48 | 1.0% |
| 8.79 | 47 | 0.9% |
| 5.59 | 40 | 0.8% |
| 11.43 | 36 | 0.7% |
| 13.48 | 36 | 0.7% |
| Other values (476) | 2139 |
| Value | Count | Frequency (%) |
| 0 | 2356 | |
| 2.97 | 2 | < 0.1% |
| 3.19 | 18 | 0.4% |
| 3.2 | 6 | 0.1% |
| 3.43 | 1 | < 0.1% |
| 3.99 | 5 | 0.1% |
| 4 | 4 | 0.1% |
| 4.06 | 4 | 0.1% |
| 4.15 | 3 | 0.1% |
| 4.16 | 10 | 0.2% |
| Value | Count | Frequency (%) |
| 155.09 | 2 | |
| 133.48 | 1 | < 0.1% |
| 126.81 | 2 | |
| 125.26 | 1 | < 0.1% |
| 123 | 4 | |
| 121.08 | 2 | |
| 120.17 | 1 | < 0.1% |
| 116.98 | 3 | |
| 115.69 | 1 | < 0.1% |
| 114.73 | 1 | < 0.1% |
order_grand_total
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 694 |
|---|---|
| Distinct (%) | 13.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 161.364346 |
| Minimum | 19.85 |
|---|---|
| Maximum | 1309.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 19.85 |
|---|---|
| 5-th percentile | 67.9 |
| Q1 | 89.85 |
| median | 129.9 |
| Q3 | 186.95 |
| 95-th percentile | 384.85 |
| Maximum | 1309.9 |
| Range | 1290.05 |
| Interquartile range (IQR) | 97.1 |
Descriptive statistics
| Standard deviation | 129.3543294 |
|---|---|
| Coefficient of variation (CV) | 0.8016289387 |
| Kurtosis | 19.73849868 |
| Mean | 161.364346 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 3.728411865 |
| Sum | 806821.73 |
| Variance | 16732.54254 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 109.9 | 174 | 3.5% |
| 89.95 | 96 | 1.9% |
| 99.95 | 85 | 1.7% |
| 89.9 | 79 | 1.6% |
| 112.54 | 78 | 1.6% |
| 134.95 | 78 | 1.6% |
| 74.95 | 77 | 1.5% |
| 99.9 | 77 | 1.5% |
| 79.9 | 69 | 1.4% |
| 149.9 | 67 | 1.3% |
| Other values (684) | 4120 |
| Value | Count | Frequency (%) |
| 19.85 | 2 | |
| 22.9 | 1 | < 0.1% |
| 24.95 | 2 | |
| 29.9 | 1 | < 0.1% |
| 29.95 | 3 | |
| 32.85 | 1 | < 0.1% |
| 32.9 | 2 | |
| 33.68 | 1 | < 0.1% |
| 33.69 | 2 | |
| 34.95 | 2 |
| Value | Count | Frequency (%) |
| 1309.9 | 2 | < 0.1% |
| 1174.55 | 8 | |
| 1146.9 | 4 | |
| 1059.9 | 2 | < 0.1% |
| 1057.6 | 8 | |
| 911.51 | 2 | < 0.1% |
| 889.9 | 1 | < 0.1% |
| 879.8 | 2 | < 0.1% |
| 849.9 | 1 | < 0.1% |
| 822.85 | 2 | < 0.1% |
| Distinct | 467 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2020-09-08 23:24:00 |
|---|---|
| Maximum | 2020-10-03 11:40:00 |
tool_import_date
Date
| Distinct | 395 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2020-09-08 23:30:00 |
|---|---|
| Maximum | 2020-10-03 11:45:00 |
| Distinct | 49 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2020-09-09 00:00:00 |
|---|---|
| Maximum | 2020-11-20 00:00:00 |
| Distinct | 58 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2020-09-11 00:00:00 |
|---|---|
| Maximum | 2020-12-01 00:00:00 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2356 |
| Missing (%) | 47.1% |
| Memory size | 39.2 KiB |
| WaitingForShipmentAcceptation | |
|---|---|
| Shipped | |
| CancelledByCustomer | 33 |
Length
| Max length | 29 |
|---|---|
| Median length | 29 |
| Mean length | 24.98108926 |
| Min length | 7 |
Characters and Unicode
| Total characters | 66050 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WaitingForShipmentAcceptation |
|---|---|
| 2nd row | WaitingForShipmentAcceptation |
| 3rd row | WaitingForShipmentAcceptation |
| 4th row | WaitingForShipmentAcceptation |
| 5th row | WaitingForShipmentAcceptation |
Common Values
| Value | Count | Frequency (%) |
| WaitingForShipmentAcceptation | 2143 | |
| Shipped | 468 | 9.4% |
| CancelledByCustomer | 33 | 0.7% |
| (Missing) | 2356 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| waitingforshipmentacceptation | 2143 | |
| shipped | 468 | 17.7% |
| cancelledbycustomer | 33 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 9040 | |
| t | 8605 | |
| n | 6462 | |
| p | 5222 | 7.9% |
| e | 4853 | 7.3% |
| c | 4319 | 6.5% |
| o | 4319 | 6.5% |
| a | 4319 | 6.5% |
| S | 2611 | 4.0% |
| h | 2611 | 4.0% |
| Other values (13) | 13689 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 56911 | |
| Uppercase Letter | 9139 | 13.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 9040 | |
| t | 8605 | |
| n | 6462 | |
| p | 5222 | |
| e | 4853 | |
| c | 4319 | |
| o | 4319 | |
| a | 4319 | |
| h | 2611 | 4.6% |
| r | 2176 | 3.8% |
| Other values (7) | 4985 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2611 | |
| A | 2143 | |
| W | 2143 | |
| F | 2143 | |
| C | 66 | 0.7% |
| B | 33 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 66050 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 9040 | |
| t | 8605 | |
| n | 6462 | |
| p | 5222 | 7.9% |
| e | 4853 | 7.3% |
| c | 4319 | 6.5% |
| o | 4319 | 6.5% |
| a | 4319 | 6.5% |
| S | 2611 | 4.0% |
| h | 2611 | 4.0% |
| Other values (13) | 13689 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 66050 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 9040 | |
| t | 8605 | |
| n | 6462 | |
| p | 5222 | 7.9% |
| e | 4853 | 7.3% |
| c | 4319 | 6.5% |
| o | 4319 | 6.5% |
| a | 4319 | 6.5% |
| S | 2611 | 4.0% |
| h | 2611 | 4.0% |
| Other values (13) | 13689 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.0 KiB |
| False | |
|---|---|
| True | 427 |
| Value | Count | Frequency (%) |
| False | 4573 | |
| True | 427 | 8.5% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Awaiting shipment | |
|---|---|
| Awaiting Protocol | |
| Cancelled | 72 |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.8848 |
| Min length | 9 |
Characters and Unicode
| Total characters | 84424 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Awaiting shipment |
|---|---|
| 2nd row | Awaiting shipment |
| 3rd row | Awaiting shipment |
| 4th row | Awaiting shipment |
| 5th row | Awaiting shipment |
Common Values
| Value | Count | Frequency (%) |
| Awaiting shipment | 3531 | |
| Awaiting Protocol | 1397 | 27.9% |
| Cancelled | 72 | 1.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| awaiting | 4928 | |
| shipment | 3531 | |
| protocol | 1397 | 14.1% |
| cancelled | 72 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 13387 | |
| t | 9856 | |
| n | 8531 | |
| a | 5000 | 5.9% |
| A | 4928 | 5.8% |
| g | 4928 | 5.8% |
| 4928 | 5.8% | |
| w | 4928 | 5.8% |
| o | 4191 | 5.0% |
| e | 3675 | 4.4% |
| Other values (10) | 20072 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 73099 | |
| Uppercase Letter | 6397 | 7.6% |
| Space Separator | 4928 | 5.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 13387 | |
| t | 9856 | |
| n | 8531 | |
| a | 5000 | 6.8% |
| g | 4928 | 6.7% |
| w | 4928 | 6.7% |
| o | 4191 | 5.7% |
| e | 3675 | 5.0% |
| m | 3531 | 4.8% |
| p | 3531 | 4.8% |
| Other values (6) | 11541 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4928 | |
| P | 1397 | 21.8% |
| C | 72 | 1.1% |
Space Separator
| Value | Count | Frequency (%) |
| 4928 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 79496 | |
| Common | 4928 | 5.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 13387 | |
| t | 9856 | |
| n | 8531 | |
| a | 5000 | 6.3% |
| A | 4928 | 6.2% |
| g | 4928 | 6.2% |
| w | 4928 | 6.2% |
| o | 4191 | 5.3% |
| e | 3675 | 4.6% |
| m | 3531 | 4.4% |
| Other values (9) | 16541 |
Common
| Value | Count | Frequency (%) |
| 4928 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 84424 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 13387 | |
| t | 9856 | |
| n | 8531 | |
| a | 5000 | 5.9% |
| A | 4928 | 5.8% |
| g | 4928 | 5.8% |
| 4928 | 5.8% | |
| w | 4928 | 5.8% |
| o | 4191 | 5.0% |
| e | 3675 | 4.4% |
| Other values (10) | 20072 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5000 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5000 |
order_place_time
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 25 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.054 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 157 |
| Zeros (%) | 3.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 13 |
| 95-th percentile | 23 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.123063358 |
|---|---|
| Coefficient of variation (CV) | 1.009790666 |
| Kurtosis | -0.4649431463 |
| Mean | 7.054 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.9391620349 |
| Sum | 35270 |
| Variance | 50.73803161 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1263 | |
| 2 | 747 | |
| 3 | 406 | 8.1% |
| 4 | 231 | 4.6% |
| 5 | 224 | 4.5% |
| 16 | 210 | 4.2% |
| 13 | 180 | 3.6% |
| 12 | 176 | 3.5% |
| 23 | 160 | 3.2% |
| 0 | 157 | 3.1% |
| Other values (15) | 1246 |
| Value | Count | Frequency (%) |
| 0 | 157 | 3.1% |
| 1 | 1263 | |
| 2 | 747 | |
| 3 | 406 | 8.1% |
| 4 | 231 | 4.6% |
| 5 | 224 | 4.5% |
| 6 | 107 | 2.1% |
| 7 | 62 | 1.2% |
| 8 | 84 | 1.7% |
| 9 | 98 | 2.0% |
| Value | Count | Frequency (%) |
| 24 | 101 | |
| 23 | 160 | |
| 22 | 38 | 0.8% |
| 21 | 23 | 0.5% |
| 20 | 55 | 1.1% |
| 19 | 115 | |
| 18 | 77 | 1.5% |
| 17 | 104 | |
| 16 | 210 | |
| 15 | 138 |
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3848 |
| Minimum | -15 |
|---|---|
| Maximum | 22 |
| Zeros | 2063 |
| Zeros (%) | 41.3% |
| Negative | 20 |
| Negative (%) | 0.4% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | -15 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 22 |
| Range | 37 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.260121809 |
|---|---|
| Coefficient of variation (CV) | 1.632092583 |
| Kurtosis | 17.51197933 |
| Mean | 1.3848 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.997600968 |
| Sum | 6924 |
| Variance | 5.10815059 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2063 | |
| 1 | 1429 | |
| 2 | 457 | 9.1% |
| 3 | 410 | 8.2% |
| 4 | 324 | 6.5% |
| 5 | 92 | 1.8% |
| 7 | 75 | 1.5% |
| 6 | 37 | 0.7% |
| 8 | 27 | 0.5% |
| 10 | 19 | 0.4% |
| Other values (19) | 67 | 1.3% |
| Value | Count | Frequency (%) |
| -15 | 3 | 0.1% |
| -14 | 3 | 0.1% |
| -13 | 4 | 0.1% |
| -10 | 1 | < 0.1% |
| -8 | 3 | 0.1% |
| -7 | 3 | 0.1% |
| -6 | 2 | < 0.1% |
| -2 | 1 | < 0.1% |
| 0 | 2063 | |
| 1 | 1429 |
| Value | Count | Frequency (%) |
| 22 | 2 | < 0.1% |
| 19 | 6 | |
| 18 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 16 | 6 | |
| 15 | 2 | < 0.1% |
| 14 | 6 | |
| 13 | 1 | < 0.1% |
| 12 | 8 | |
| 11 | 6 |
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9474 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 2212 |
| Zeros (%) | 44.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.45019059 |
|---|---|
| Coefficient of variation (CV) | 1.258185576 |
| Kurtosis | 10.86742105 |
| Mean | 1.9474 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.318136007 |
| Sum | 9737 |
| Variance | 6.003433927 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2212 | |
| 2 | 736 | 14.7% |
| 4 | 681 | 13.6% |
| 3 | 462 | 9.2% |
| 5 | 338 | 6.8% |
| 1 | 329 | 6.6% |
| 6 | 71 | 1.4% |
| 7 | 57 | 1.1% |
| 8 | 37 | 0.7% |
| 11 | 14 | 0.3% |
| Other values (11) | 63 | 1.3% |
| Value | Count | Frequency (%) |
| 0 | 2212 | |
| 1 | 329 | 6.6% |
| 2 | 736 | 14.7% |
| 3 | 462 | 9.2% |
| 4 | 681 | 13.6% |
| 5 | 338 | 6.8% |
| 6 | 71 | 1.4% |
| 7 | 57 | 1.1% |
| 8 | 37 | 0.7% |
| 9 | 12 | 0.2% |
| Value | Count | Frequency (%) |
| 23 | 4 | 0.1% |
| 22 | 2 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 5 | 0.1% |
| 16 | 4 | 0.1% |
| 15 | 7 | |
| 14 | 7 | |
| 13 | 9 | |
| 12 | 1 | < 0.1% |
| 11 | 14 |
order_total_time
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 46 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.3862 |
| Minimum | 0 |
|---|---|
| Maximum | 48 |
| Zeros | 157 |
| Zeros (%) | 3.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 16 |
| 95-th percentile | 26 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 8.115480378 |
|---|---|
| Coefficient of variation (CV) | 0.7813714716 |
| Kurtosis | 0.4843135273 |
| Mean | 10.3862 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.9934974334 |
| Sum | 51931 |
| Variance | 65.86102176 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 456 | 9.1% |
| 4 | 390 | 7.8% |
| 5 | 379 | 7.6% |
| 2 | 308 | 6.2% |
| 8 | 303 | 6.1% |
| 6 | 303 | 6.1% |
| 9 | 262 | 5.2% |
| 7 | 260 | 5.2% |
| 10 | 166 | 3.3% |
| 23 | 159 | 3.2% |
| Other values (36) | 2014 |
| Value | Count | Frequency (%) |
| 0 | 157 | 3.1% |
| 1 | 132 | 2.6% |
| 2 | 308 | |
| 3 | 456 | |
| 4 | 390 | |
| 5 | 379 | |
| 6 | 303 | |
| 7 | 260 | |
| 8 | 303 | |
| 9 | 262 |
| Value | Count | Frequency (%) |
| 48 | 4 | |
| 47 | 2 | |
| 46 | 2 | |
| 45 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 39 | 3 | |
| 38 | 2 | |
| 37 | 2 | |
| 36 | 4 |
| Distinct | 1520 |
|---|---|
| Distinct (%) | 30.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.399984 |
| Minimum | -202.09 |
|---|---|
| Maximum | 604.5 |
| Zeros | 5 |
| Zeros (%) | 0.1% |
| Negative | 121 |
| Negative (%) | 2.4% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | -202.09 |
|---|---|
| 5-th percentile | 7.039 |
| Q1 | 20.3 |
| median | 31.41 |
| Q3 | 42.14 |
| 95-th percentile | 76.1 |
| Maximum | 604.5 |
| Range | 806.59 |
| Interquartile range (IQR) | 21.84 |
Descriptive statistics
| Standard deviation | 49.12753444 |
|---|---|
| Coefficient of variation (CV) | 1.313571002 |
| Kurtosis | 52.77797864 |
| Mean | 37.399984 |
| Median Absolute Deviation (MAD) | 10.78 |
| Skewness | 6.177480479 |
| Sum | 186999.92 |
| Variance | 2413.51464 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42.14 | 81 | 1.6% |
| 29.94 | 62 | 1.2% |
| 37.3 | 47 | 0.9% |
| 32.27 | 45 | 0.9% |
| 29.51 | 37 | 0.7% |
| 29.97 | 34 | 0.7% |
| 33.06 | 33 | 0.7% |
| 26.3 | 30 | 0.6% |
| 18.45 | 28 | 0.6% |
| 33.22 | 27 | 0.5% |
| Other values (1510) | 4576 |
| Value | Count | Frequency (%) |
| -202.09 | 1 | |
| -124.93 | 2 | |
| -124.28 | 2 | |
| -124.01 | 2 | |
| -116.31 | 1 | |
| -111.47 | 2 | |
| -111.07 | 1 | |
| -109.27 | 2 | |
| -100.23 | 1 | |
| -98.62 | 2 |
| Value | Count | Frequency (%) |
| 604.5 | 2 | |
| 586.02 | 2 | |
| 532.94 | 3 | |
| 483.09 | 2 | |
| 470.79 | 2 | |
| 468.91 | 1 | < 0.1% |
| 466.04 | 2 | |
| 455.05 | 2 | |
| 454.39 | 1 | < 0.1% |
| 451.94 | 4 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| line_type | mkp_name | mkp_order_no | order_date | ordoro_id | sku | item_sale_price | item_tax | shipping_sale | total_per_sku | title | supplier_name | order_status | item_cost | cancelled_value | transport_cost_est | first_pick_date | last_delivery_date | courier | mage_mkp_commission | mkp_estimated_commission | mkp_actual_commission | order_grand_total | ordoro_import_date | tool_import_date | max_shipping_date | max_delivery_date | cd_status | is_clogistique_order | line_status | transport_cost_actual | order_place_time | order_prep_time | order_delivery_time | order_total_time | gm_estimated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ORDER LINE | CDiscount | 2009161727KUPJE | 2020-09-16 15:27:00 | 1-300055647 | KK-KKLJOYBLU00000 | 69.95 | 0 | 9.95 | 79.90 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 1.92 | 0.00 | 13.90 | 81.82 | 2020-09-16 19:46:00 | 2020-09-16 19:51:00 | 2020-09-30 | 2020-10-09 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 16 | 0 | 0 | 16 | 51.08 |
| 1 | ORDER LINE | CDiscount | 2009161727KUPJE | 2020-09-16 15:27:00 | 1-300055647 | KK-KKLJOYBLU00000 | 69.95 | 0 | 9.95 | 79.90 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 1.92 | 0.00 | 13.90 | 81.82 | 2020-09-16 19:46:00 | 2020-09-16 19:51:00 | 2020-09-30 | 2020-10-09 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 16 | 0 | 0 | 16 | 51.08 |
| 2 | ORDER LINE | PriceMinister | 322836927 | 2020-09-24 22:25:00 | 1-300056586 | KK-KKWMOOVNAV0000 | 319.95 | 0 | 0.00 | 319.95 | NaN | KK | shipped | 171.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 47.99 | 0.00 | 319.95 | 2020-09-25 00:49:00 | 2020-09-25 00:51:00 | 2020-10-05 | 2020-10-08 | NaN | No | Awaiting shipment | 0 | 8 | 0 | 0 | 8 | 47.64 |
| 3 | ORDER LINE | Monechelle | M200923734296 | 2020-09-25 08:47:00 | 1-300056600 | KK-KKLJOYBLU000AC | 79.95 | 0 | 0.00 | 79.95 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 11.99 | 0.00 | 79.95 | 2020-09-25 12:02:00 | 2020-09-25 12:10:00 | 2020-10-02 | 2020-10-13 | NaN | No | Awaiting shipment | 0 | 8 | 0 | 0 | 8 | 54.64 |
| 4 | ORDER LINE | Monechelle | M200923740097 | 2020-09-25 13:11:00 | 1-300056647 | KK-KKLJOYBLU000AC | 79.95 | 0 | 0.00 | 79.95 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 11.99 | 0.00 | 79.95 | 2020-09-25 15:22:00 | 2020-09-25 15:30:00 | 2020-10-02 | 2020-10-13 | NaN | No | Awaiting shipment | 0 | 7 | 0 | 0 | 7 | 54.64 |
| 5 | ORDER LINE | Monechelle | M200923816976 | 2020-09-28 16:05:00 | 1-300057121 | KK-KKKFINIBLK0000 | 119.95 | 0 | 0.00 | 119.95 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 17.99 | 0.00 | 119.95 | 2020-09-28 18:36:00 | 2020-09-28 18:45:00 | 2020-10-05 | 2020-10-14 | NaN | No | Awaiting shipment | 0 | 4 | 0 | 0 | 4 | 81.97 |
| 6 | ORDER LINE | Monechelle | M200923816976 | 2020-09-28 16:05:00 | 1-300057121 | KK-KKKFINIBLK0000 | 119.95 | 0 | 0.00 | 119.95 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 17.99 | 0.00 | 119.95 | 2020-09-28 18:36:00 | 2020-09-28 18:45:00 | 2020-10-05 | 2020-10-14 | NaN | No | Awaiting shipment | 0 | 4 | 0 | 0 | 4 | 81.97 |
| 7 | ORDER LINE | CDiscount | 20092821212SYQB | 2020-09-28 19:21:00 | 1-300057167 | KK-KKFJUFIBLK0000 | 79.95 | 0 | 9.95 | 89.90 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 0.00 | 13.48 | 89.90 | 2020-09-28 22:19:00 | 2020-09-28 22:30:00 | 2020-10-12 | 2020-10-21 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 4 | 0 | 0 | 4 | 61.44 |
| 8 | ORDER LINE | CDiscount | 20092821212SYQB | 2020-09-28 19:21:00 | 1-300057167 | KK-KKFJUFIBLK0000 | 79.95 | 0 | 9.95 | 89.90 | NaN | KK | shipped | 0.00 | 0.0 | 0.0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 0.00 | 13.48 | 89.90 | 2020-09-28 22:19:00 | 2020-09-28 22:30:00 | 2020-10-12 | 2020-10-21 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 4 | 0 | 0 | 4 | 61.44 |
| 9 | ORDER LINE | CDiscount | 20090822540NKZH | 2020-09-08 20:54:00 | 1-300054777 | AKO-K120-6SZ-BIALA | 124.95 | 0 | 19.95 | 144.90 | NaN | AKO | shipped | 39.16 | 0.0 | 16.0 | 2020-09-10 11:15:00 | 0000-00-00 00:00:00 | UPS | 0.00 | 0.00 | 21.73 | 144.90 | 2020-09-09 00:33:00 | 2020-09-09 00:45:00 | 2020-09-23 | 2020-10-02 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 24 | 1 | 23 | 48 | 43.86 |
Last rows
| line_type | mkp_name | mkp_order_no | order_date | ordoro_id | sku | item_sale_price | item_tax | shipping_sale | total_per_sku | title | supplier_name | order_status | item_cost | cancelled_value | transport_cost_est | first_pick_date | last_delivery_date | courier | mage_mkp_commission | mkp_estimated_commission | mkp_actual_commission | order_grand_total | ordoro_import_date | tool_import_date | max_shipping_date | max_delivery_date | cd_status | is_clogistique_order | line_status | transport_cost_actual | order_place_time | order_prep_time | order_delivery_time | order_total_time | gm_estimated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4990 | ORDER LINE | Monechelle | M200923366641 | 2020-09-09 08:03:00 | 1-300054799 | VOX-4011330 | 751.95 | 0 | 0.00 | 751.95 | NaN | VOX | awaiting_fulfillment | 231.00 | 0.0 | 145.00 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 112.79 | 0.00 | 751.95 | 2020-09-09 09:52:00 | 2020-09-09 10:00:00 | 2020-09-16 | 2020-09-25 | NaN | No | Awaiting Protocol | 0 | 24 | 0 | 0 | 24 | 137.84 |
| 4991 | ORDER LINE | CDiscount | 2009102124W8UBM | 2020-09-10 19:24:00 | 1-300055026 | VOX-5010521 | 79.95 | 0 | 9.95 | 89.90 | NaN | VOX | shipped | 37.00 | 0.0 | 16.00 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 0.00 | 13.48 | 89.90 | 2020-09-10 23:42:00 | 2020-09-10 23:45:00 | 2020-09-24 | 2020-10-05 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 22 | 0 | 0 | 22 | 8.44 |
| 4992 | ORDER LINE | CDiscount | 20092319183OWKB | 2020-09-23 17:18:00 | 1-300056455 | VOX-4013666 | 129.95 | 0 | 19.95 | 149.90 | NaN | VOX | awaiting_fulfillment | 43.00 | 0.0 | 35.85 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | DPD | 3.59 | 0.00 | 26.07 | 153.49 | 2020-09-23 21:07:00 | 2020-09-23 21:10:00 | 2020-10-07 | 2020-10-16 | WaitingForShipmentAcceptation | No | Awaiting Protocol | 0 | 4 | 5 | 0 | 9 | 17.01 |
| 4993 | ORDER LINE | CDiscount | 20092416353KX8G | 2020-09-24 14:35:00 | 1-300056540 | VOX-4010752 | 198.95 | 0 | 19.95 | 218.90 | NaN | VOX | awaiting_fulfillment | 84.00 | 0.0 | 32.01 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | DPD | 0.00 | 0.00 | 32.83 | 218.90 | 2020-09-24 18:48:00 | 2020-09-24 18:51:00 | 2020-10-08 | 2020-10-19 | WaitingForShipmentAcceptation | No | Awaiting Protocol | 0 | 3 | 5 | 0 | 8 | 33.58 |
| 4994 | ORDER LINE | conforama | 4913779302-A | 2020-10-01 18:30:00 | 1-300057705 | VOX-5010418 | 540.95 | 0 | 19.95 | 560.90 | NaN | VOX | awaiting_fulfillment | 141.00 | 0.0 | 145.00 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 91.96 | 0.00 | 560.90 | 2020-10-02 00:23:00 | 2020-10-02 00:30:00 | 2020-10-15 | 2020-10-26 | NaN | No | Awaiting Protocol | 0 | 1 | 0 | 0 | 1 | 89.46 |
| 4995 | ORDER LINE | Monechelle | M201023911286 | 2020-10-02 08:57:00 | 1-300057740 | VOX-5010521 | 89.95 | 0 | 0.00 | 89.95 | NaN | VOX | awaiting_fulfillment | 37.00 | 0.0 | 10.07 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NaN | 0.00 | 13.49 | 0.00 | 89.95 | 2020-10-02 11:45:00 | 2020-10-02 11:46:00 | 2020-10-09 | 2020-10-20 | NaN | No | Awaiting Protocol | 0 | 1 | 0 | 0 | 1 | 14.40 |
| 4996 | ORDER LINE | CDiscount | 2009111343V40SI | 2020-09-11 11:43:00 | 1-300055062 | TO-SZAFKA-S33-BIEL-MAT | 67.85 | 0 | 9.95 | 77.80 | NaN | TO | shipped | 23.98 | 0.0 | 0.00 | 2020-09-24 21:18:00 | 2020-09-29 21:22:00 | DPD | 0.00 | 0.00 | 11.67 | 77.80 | 2020-09-11 15:11:00 | 2020-09-11 15:15:00 | 2020-09-25 | 2020-10-06 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 11 | 1 | 5 | 17 | 29.18 |
| 4997 | ORDER LINE | Monechelle | M200923492535 | 2020-09-14 15:44:00 | 1-300055403 | TO-SZAFKA-S33-BIEL-MAT | 79.95 | 0 | 0.00 | 79.95 | NaN | TO | shipped | 23.98 | 0.0 | 0.00 | 2020-09-24 21:15:00 | 2020-09-30 18:49:00 | DPD | 0.00 | 11.99 | 0.00 | 79.95 | 2020-09-14 18:16:00 | 2020-09-14 18:30:00 | 2020-09-21 | 2020-09-30 | NaN | No | Awaiting shipment | 0 | 8 | 1 | 5 | 14 | 30.66 |
| 4998 | ORDER LINE | CDiscount | 2009210907BZSN1 | 2020-09-21 07:07:00 | 1-300056153 | TO-SZAFKA-S33-BIEL-MAT | 69.95 | 0 | 9.95 | 79.90 | NaN | TO | shipped | 23.98 | 0.0 | 0.00 | 2020-09-24 21:18:00 | 2020-09-29 16:27:00 | DPD | 0.00 | 0.00 | 11.98 | 79.90 | 2020-09-21 10:53:00 | 2020-09-21 11:00:00 | 2020-10-05 | 2020-10-14 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 2 | 1 | 4 | 7 | 30.62 |
| 4999 | ORDER LINE | CDiscount | 2009210907BZSN1 | 2020-09-21 07:07:00 | 1-300056153 | TO-SZAFKA-S33-BIEL-MAT | 69.95 | 0 | 9.95 | 79.90 | NaN | TO | shipped | 23.98 | 0.0 | 0.00 | 2020-09-24 21:18:00 | 2020-09-29 16:27:00 | DPD | 0.00 | 0.00 | 11.98 | 79.90 | 2020-09-21 10:53:00 | 2020-09-21 11:00:00 | 2020-10-05 | 2020-10-14 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 2 | 1 | 4 | 7 | 30.62 |
Most frequently occurring
| line_type | mkp_name | order_date | ordoro_id | sku | item_sale_price | item_tax | shipping_sale | total_per_sku | supplier_name | order_status | item_cost | cancelled_value | transport_cost_est | courier | mage_mkp_commission | mkp_estimated_commission | mkp_actual_commission | order_grand_total | ordoro_import_date | tool_import_date | max_shipping_date | max_delivery_date | cd_status | is_clogistique_order | line_status | transport_cost_actual | order_place_time | order_prep_time | order_delivery_time | order_total_time | gm_estimated | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23 | ORDER LINE | CDiscount | 2020-09-09 13:38:00 | 1-300054839 | TOP-R40/black | 57.95 | 0 | 9.95 | 67.90 | TOP | shipped | 18.43 | 0.0 | 15.95 | DPD | 1.63 | 0.0 | 11.82 | 278.12 | 2020-09-09 16:42:00 | 2020-09-09 16:45:00 | 2020-09-23 | 2020-10-02 | Shipped | No | Awaiting shipment | 0 | 23 | 1 | 7 | 31 | 9.03 | 8 |
| 14 | ORDER LINE | CDiscount | 2020-09-09 09:52:00 | 1-300054812 | TOP-S33/sonoma | 68.95 | 0 | 9.95 | 78.90 | TOP | shipped | 23.98 | 0.0 | 15.95 | DPD | 1.89 | 0.0 | 13.73 | 161.58 | 2020-09-09 13:15:00 | 2020-09-09 13:30:00 | 2020-09-23 | 2020-10-02 | Shipped | No | Awaiting shipment | 0 | 24 | 1 | 4 | 29 | 10.52 | 4 |
| 25 | ORDER LINE | CDiscount | 2020-09-09 13:52:00 | 1-300054843 | TOP-KaroK2/sonoma | 49.95 | 0 | 13.28 | 63.23 | TOP | shipped | 16.82 | 0.0 | 13.67 | UPS | 2.24 | 0.0 | 16.22 | 286.42 | 2020-09-09 16:42:00 | 2020-09-09 16:45:00 | 2020-09-23 | 2020-10-02 | Shipped | No | Awaiting shipment | 0 | 23 | 0 | 4 | 27 | 4.12 | 4 |
| 38 | ORDER LINE | CDiscount | 2020-09-09 16:33:00 | 1-300054874 | AKO-K140-10SZ-BIALA | 224.95 | 0 | 19.95 | 244.90 | AKO | shipped | 69.57 | 0.0 | 16.00 | UPS | 0.00 | 0.0 | 36.74 | 489.80 | 2020-09-09 19:59:00 | 2020-09-09 20:00:00 | 2020-10-14 | 2020-10-23 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 14 | 4 | 5 | 23 | 81.77 | 4 |
| 52 | ORDER LINE | CDiscount | 2020-09-09 20:38:00 | 1-300054909 | AKO-BIURKO-PIN-BIALE | 79.95 | 0 | 9.95 | 89.90 | AKO | shipped | 28.43 | 0.0 | 15.95 | DPD | 0.00 | 0.0 | 13.49 | 179.80 | 2020-09-09 23:24:00 | 2020-09-09 23:30:00 | 2020-09-23 | 2020-10-02 | Shipped | No | Awaiting shipment | 0 | 23 | 0 | 4 | 27 | 17.05 | 4 |
| 112 | ORDER LINE | CDiscount | 2020-09-17 09:25:00 | 1-300055713 | TOP-S30/sonoma | 66.95 | 0 | 9.95 | 76.90 | TOP | shipped | 23.08 | 0.0 | 15.95 | DPD | 0.00 | 0.0 | 11.54 | 153.80 | 2020-09-17 12:13:00 | 2020-09-17 12:15:00 | 2020-10-01 | 2020-10-12 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 16 | 4 | 3 | 23 | 13.51 | 4 |
| 146 | ORDER LINE | CDiscount | 2020-09-18 10:33:00 | 1-300055818 | AKO-K60-6SZ-BIALA-POLYSK | 219.95 | 0 | 19.95 | 239.90 | AKO | shipped | 80.30 | 0.0 | 16.00 | UPS | 5.76 | 0.0 | 41.74 | 491.31 | 2020-09-18 14:04:00 | 2020-09-18 14:10:00 | 2020-10-02 | 2020-10-13 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 2 | 3 | 5 | 10 | 57.08 | 4 |
| 192 | ORDER LINE | CDiscount | 2020-09-20 05:45:00 | 1-300056015 | TOP-MalwaM6/140/white | 114.95 | 0 | 34.95 | 149.90 | TOP | shipped | 43.95 | 0.0 | 16.00 | UPS | 11.40 | 0.0 | 23.84 | 277.00 | 2020-09-20 09:11:00 | 2020-09-20 09:15:00 | 2020-10-05 | 2020-10-14 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 13 | 3 | 7 | 23 | 31.63 | 4 |
| 223 | ORDER LINE | CDiscount | 2020-09-20 18:42:00 | 1-300056117 | TOP-MalwaM6/140/sonoma | 114.95 | 0 | 19.95 | 134.90 | TOP | shipped | 43.95 | 0.0 | 16.00 | UPS | 0.00 | 0.0 | 20.24 | 269.80 | 2020-09-20 21:44:00 | 2020-09-20 21:45:00 | 2020-10-02 | 2020-10-13 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 12 | 2 | 5 | 19 | 32.23 | 4 |
| 263 | ORDER LINE | CDiscount | 2020-09-27 13:40:00 | 1-300056941 | AKO-K120-6SZ-BIALA | 89.95 | 0 | 19.95 | 109.90 | AKO | shipped | 39.16 | 0.0 | 0.00 | UPS | 2.64 | 0.0 | 11.43 | 225.08 | 2020-09-27 18:15:00 | 2020-09-27 18:30:00 | 2020-10-09 | 2020-10-20 | WaitingForShipmentAcceptation | No | Awaiting shipment | 0 | 5 | 1 | 3 | 9 | 38.79 | 4 |